package com.zhuqieli.database_learn.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zhuqieli.database_learn.pojo.UserTable;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import org.apache.ibatis.annotations.Param;

/**
 * @author dupr
 * @description 用户mapper
 * @date 2023/8/30 19:55:09
 */
@Mapper
public interface UserTableMapper extends BaseMapper<UserTable> {
    @Select("SELECT id FROM user_table WHERE name = #{name}")
    Integer findIdByName(String name);

    UserTable findByAccount(@Param("account") String account);

}
